USE [xRepair]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetAllActiveUsers]	
AS
BEGIN

	SET NOCOUNT ON;

	SELECT [ID]
		,[RoleID]
		,[Username]
		,[Password]
		,[Salt]
		,[Alias]
		,[EmailAddress]
		,[ActivationCode]
		,[CreatedAt]
		,[CreatedBy]
		,[LastUpdatedAt]
		,[LastUpdatedBy]
	FROM [xRepair].[dbo].[Users] WITH(NOLOCK)
	WHERE [IsActive] = 1 OR [IsActive] IS NULL

END

